/*
 Navicat Premium Data Transfer

 Source Server         : mysql_localhost
 Source Server Type    : MySQL
 Source Server Version : 50562
 Source Host           : 127.0.0.1:3306
 Source Schema         : cm-shell

 Target Server Type    : MySQL
 Target Server Version : 50562
 File Encoding         : 65001

 Date: 02/07/2021 15:58:28
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for host
-- ----------------------------
DROP TABLE IF EXISTS `host`;
CREATE TABLE `host` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `port` int(11) DEFAULT NULL,
  `hostname` varchar(255) DEFAULT NULL,
  `group` varchar(255) DEFAULT NULL,
  `host` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group-key` (`group`),
  CONSTRAINT `group-key` FOREIGN KEY (`group`) REFERENCES `hostgroup` (`Name`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of host
-- ----------------------------
BEGIN;
INSERT INTO `host` VALUES (23, 'root', '123.com', 22, 'hellowolrd01', 'hellowolrd', 'hellowolrd01');
INSERT INTO `host` VALUES (24, 'root', '123.com', 22, 'hellowolrd02', 'hellowolrd', 'hellowolrd02');
COMMIT;

-- ----------------------------
-- Table structure for hostgroup
-- ----------------------------
DROP TABLE IF EXISTS `hostgroup`;
CREATE TABLE `hostgroup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) NOT NULL,
  `Descrs` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `Name` (`Name`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of hostgroup
-- ----------------------------
BEGIN;
INSERT INTO `hostgroup` VALUES (26, 'hellowolrd', 'hellowolrd');
COMMIT;

-- ----------------------------
-- Table structure for task
-- ----------------------------
DROP TABLE IF EXISTS `task`;
CREATE TABLE `task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `task` varchar(255) NOT NULL,
  `template` varchar(255) NOT NULL,
  `group` varchar(255) NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of task
-- ----------------------------
BEGIN;
INSERT INTO `task` VALUES (40, 'task.rbcjQzTNXl', 'java', 'javaProject', NULL, '111', '2021-06-30 08:36:00');
INSERT INTO `task` VALUES (41, '', 'hcw-project', '', NULL, '111', '2021-06-30 10:03:00');
INSERT INTO `task` VALUES (42, '', 'hcw-project', 'javaProject', NULL, '111', '2021-06-30 10:04:00');
INSERT INTO `task` VALUES (43, 'task.iQMpS2jKG9', 'hcw-project', 'javaProject', NULL, '111', '2021-06-30 10:06:00');
INSERT INTO `task` VALUES (44, 'task.aC3FEqhPB8', 'hcw-project', 'javaProject', NULL, '111', '2021-06-30 10:06:00');
INSERT INTO `task` VALUES (45, 'task.lutrOMOEKt', 'hcw-project', 'javaProject', NULL, '111', '2021-06-30 10:06:00');
INSERT INTO `task` VALUES (46, 'task.GWoINDKJtO', 'hcw-project', 'javaProject', NULL, '111', '2021-06-30 10:06:00');
INSERT INTO `task` VALUES (47, 'task.PtonmTpveS', 'hcw-project', 'javaProject', NULL, '111', '2021-06-30 10:08:00');
INSERT INTO `task` VALUES (48, 'task.IUAeOC89rr', 'hcw-project', 'javaProject', NULL, '111', '2021-06-30 11:11:00');
INSERT INTO `task` VALUES (49, 'task.Db8iCjKDdR', 'hcw-project', 'javaProject', NULL, '11', '2021-06-30 11:22:00');
INSERT INTO `task` VALUES (50, 'task.zXUvMX17s3', 'hcw-project02', 'javaProject', NULL, '11', '2021-06-30 11:22:00');
INSERT INTO `task` VALUES (51, 'task.pSCr4xT7xw', 'hcw-project', 'javaProject', NULL, '1', '2021-06-30 11:23:00');
INSERT INTO `task` VALUES (52, 'task.JxU9bKJ3WY', 'hcw-project02', 'javaProject', NULL, '111', '2021-06-30 11:23:00');
INSERT INTO `task` VALUES (53, 'task.d2KiZzwQsi', 'hcw-project02', 'javaProject', NULL, '111', '2021-06-30 11:23:00');
INSERT INTO `task` VALUES (54, 'task.PleRSXYn42', 'hcw-project02', 'javaProject', NULL, '111', '2021-06-30 11:23:00');
INSERT INTO `task` VALUES (55, 'task.EhXUZvfvuN', 'hcw-project02', 'javaProject', NULL, '111', '2021-06-30 11:24:00');
INSERT INTO `task` VALUES (56, 'task.gizOPACk1g', 'hcw-project02', 'javaProject', NULL, '111', '2021-06-30 11:24:00');
INSERT INTO `task` VALUES (57, 'task.rZ3gWw41hL', 'hcw-project02', 'javaProject', NULL, '111', '2021-06-30 11:24:00');
INSERT INTO `task` VALUES (58, 'task.h3qUR4rKsI', 'hcw-project', 'javaProject', NULL, '11', '2021-06-30 11:35:00');
INSERT INTO `task` VALUES (59, 'task.b7w8vGNJKt', 'hcw-project', 'javaProject', NULL, '11', '0000-00-00 00:00:00');
INSERT INTO `task` VALUES (60, 'task.xdty5wnfBv', 'hcw-project', 'javaProject', NULL, '1111', '0000-00-00 00:00:00');
INSERT INTO `task` VALUES (61, 'task.pL9qOytMst', 'hcw-project', '11', NULL, '7', '0000-00-00 00:00:00');
INSERT INTO `task` VALUES (62, 'task.xHwqXhH7Tr', 'hcw-project', 'javaProject', NULL, '111', '0000-00-00 00:00:00');
INSERT INTO `task` VALUES (63, 'task.sarNZEbzVQ', 'hcw-project', 'javaProject', NULL, '111', '0000-00-00 00:00:00');
INSERT INTO `task` VALUES (64, 'task.ymAuy0vKJp', 'hcw-project', '11', NULL, '111', '0000-00-00 00:00:00');
INSERT INTO `task` VALUES (65, 'task.H54Mit5yDn', 'hcw-project', 'hellowolrd', NULL, '111', '0000-00-00 00:00:00');
INSERT INTO `task` VALUES (66, 'task.HQ4FSzq354', 'hcw-project', 'hellowolrd', NULL, '111', '0000-00-00 00:00:00');
INSERT INTO `task` VALUES (67, 'task.AQ4jZmkhJq', 'hcw-project', 'hellowolrd', NULL, '', '0000-00-00 00:00:00');
INSERT INTO `task` VALUES (68, 'task.UMKJQrM1pI', 'hcw-project', 'hellowolrd', NULL, '111', '0000-00-00 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for template
-- ----------------------------
DROP TABLE IF EXISTS `template`;
CREATE TABLE `template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text,
  `check` text,
  `makefile` text,
  `playbook` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of template
-- ----------------------------
BEGIN;
INSERT INTO `template` VALUES (1, 'test\n-+hosts%3A+all%0D%0A++tasks%3A%0D%0A++-+name%3A+ping%0D%0A++++ping+%3A%0D%0A++-+name+%3A+hello+wolrd%0D%0A++++shell+%3A+echo+%22hello+wolrd%22', '', 'run%3A%0D%0A%09echo+%22hello+wolrd%22%0D%0Adeploy%3A%0D%0A++++ansible-playbook+++-i++++host+++playbook.yml', 'run%3A%0D%0A%09echo+%22hello+wolrd%22%0D%0Adeploy%3A%0D%0A++++ansible-playbook+++-i++++host+++playbook.yml\n-+hosts%3A+all%0D%0A++tasks%3A%0D%0A++-+name%3A+ping%0D%0A++++ping+%3A%0D%0A++-+name+%3A+hello+wolrd%0D%0A++++shell+%3A+echo+%22hello+wolrd%22');
INSERT INTO `template` VALUES (2, 'test\n-+hosts%3A+all%0D%0A++tasks%3A%0D%0A++-+name%3A+ping%0D%0A++++ping+%3A%0D%0A++-+name+%3A+hello+wolrd%0D%0A++++shell+%3A+echo+%22hello+wolrd%22', '%23%21%2Fbin%2Fbash%0D%0Aecho+%22hello++check%22', 'run%3A%0D%0A%09echo+%22hello+wolrd%22%0D%0Adeploy%3A%0D%0A++++ansible-playbook+++-i++++host+++playbook.yml', 'run%3A%0D%0A%09echo+%22hello+wolrd%22%0D%0Adeploy%3A%0D%0A++++ansible-playbook+++-i++++host+++playbook.yml\n-+hosts%3A+all%0D%0A++tasks%3A%0D%0A++-+name%3A+ping%0D%0A++++ping+%3A%0D%0A++-+name+%3A+hello+wolrd%0D%0A++++shell+%3A+echo+%22hello+wolrd%22');
INSERT INTO `template` VALUES (3, 'test01\n-+hosts%3A+all%0D%0A++tasks%3A%0D%0A++-+name%3A+ping%0D%0A++++ping+%3A%0D%0A++-+name+%3A+hello+wolrd%0D%0A++++shell+%3A+echo+%22hello+wolrd%22', '%23%21%2Fbin%2Fbash%0D%0Aecho+%22hello++check%22', 'run%3A%0D%0A%09echo+%22hello+wolrd%22%0D%0Adeploy%3A%0D%0A++++ansible-playbook+++-i++++host+++playbook.yml', 'run%3A%0D%0A%09echo+%22hello+wolrd%22%0D%0Adeploy%3A%0D%0A++++ansible-playbook+++-i++++host+++playbook.yml\n-+hosts%3A+all%0D%0A++tasks%3A%0D%0A++-+name%3A+ping%0D%0A++++ping+%3A%0D%0A++-+name+%3A+hello+wolrd%0D%0A++++shell+%3A+echo+%22hello+wolrd%22');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `token` varchar(255) DEFAULT NULL,
  `Png` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'hcw', '099b3b060154898840f0ebdfb46ec78f', 'a1275e30110671ee170eeef4e79f833d', '/static/img/user4-128x128.jpg');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
